/ Programming Languages Suite / ProgramD2.iso / Visual Database / Visual dBase v5.5 / UTILS.PAK / SQLDBASE.DBT

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 0f 00 00 00 00 00 00 00 | 53 51 4c 44 42 41 53 45 |........|SQLDBASE|
|00000010| 00 00 02 01 00 02 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000200| ff ff 08 00 22 00 00 00 | 75 73 65 20 41 6e 69 6d |...."...|use Anim|
|00000210| 61 6c 73 0d 0a 73 65 74 | 20 66 69 65 6c 64 73 20 |als..set| fields |
|00000220| 74 6f ff 98 16 2f 22 01 | 00 00 00 5a 0b d7 47 03 |to.../".|...Z..G.|
|00000230| 00 03 00 00 00 00 09 00 | 76 0e 32 33 00 00 89 01 |........|v.23....|
|00000240| 00 00 02 00 00 00 00 00 | 0a 00 00 00 08 00 00 00 |........|........|
|00000250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000260| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000280| 00 00 00 00 00 00 29 00 | 28 00 00 00 00 00 00 00 |......).|(.......|
|00000290| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002a0| 00 00 00 00 00 00 02 00 | 3b 00 00 00 00 00 00 00 |........|;.......|
|000002b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002c0| 00 00 00 00 00 00 0d 00 | 0a 0f 0a 0e 97 47 0e 0f |........|.....G..|
|000002d0| ef 47 f5 00 00 00 25 00 | 00 00 00 00 14 00 31 35 |.G....%.|......15|
|000002e0| 31 33 52 03 07 3d 92 04 | 07 3d 1e 0d 07 3d f6 0c |13R..=..|.=...=..|
|000002f0| 07 3d 46 0d 07 3d 76 0d | 07 3d fa 0f 07 3d aa 0f |.=F..=v.|.=...=..|
|00000300| 07 3d d2 0f 07 3d 22 10 | 07 3d 42 10 07 3d be 00 |.=...=".|.=B..=..|
|00000310| 97 3c d6 00 97 3c 6e 04 | 97 3c 0a 09 97 3c 86 00 |.<...<n.|.<...<..|
|00000320| 7f 0b 9e 00 7f 0b e6 0c | 7f 0b a6 0c 7f 0b 56 0c |........|......V.|
|00000330| 7f 0b 7e 0c 7f 0b ce 0c | 7f 0b fe 0c 7f 0b 2e 0d |..~.....|........|
|00000340| 7f 0b 01 00 00 00 00 00 | 0a 00 00 00 00 00 00 00 |........|........|
|00000350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000380| 00 00 00 00 00 00 25 00 | 00 00 00 00 00 00 00 00 |......%.|........|
|00000390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003a0| 00 00 00 00 00 00 14 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003c0| 00 00 00 00 00 00 00 00 | 77 f5 f7 00 1f 00 77 f5 |........|w.....w.|
|000003d0| f7 00 1f 09 77 f5 f7 00 | 1f 01 77 f5 f7 00 1f 00 |....w...|..w.....|
|000003e0| 77 90 f7 00 0f 00 77 90 | f7 00 0f 09 77 90 f7 00 |w.....w.|....w...|
|000003f0| 0f 01 77 90 f7 00 0f 00 | 77 9e f7 00 0f 00 77 9e |..w.....|w.....w.|
|00000400| ff ff 08 00 16 00 00 00 | 75 73 65 20 69 6e 20 41 |........|use in A|
|00000410| 6e 69 6d 61 6c 73 65 74 | 20 66 69 65 6c 64 73 20 |nimalset| fields |
|00000420| 74 6f ff 98 16 2f 22 01 | 00 00 00 5a 0b d7 47 03 |to.../".|...Z..G.|
|00000430| 00 03 00 00 00 00 09 00 | 76 0e 32 33 00 00 89 01 |........|v.23....|
|00000440| 00 00 02 00 00 00 00 00 | 0a 00 00 00 08 00 00 00 |........|........|
|00000450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000460| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000470| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000480| 00 00 00 00 00 00 29 00 | 28 00 00 00 00 00 00 00 |......).|(.......|
|00000490| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004a0| 00 00 00 00 00 00 02 00 | 3b 00 00 00 00 00 00 00 |........|;.......|
|000004b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004c0| 00 00 00 00 00 00 0d 00 | 0a 0f 0a 0e 97 47 0e 0f |........|.....G..|
|000004d0| ef 47 f5 00 00 00 25 00 | 00 00 00 00 14 00 31 35 |.G....%.|......15|
|000004e0| 31 33 52 03 07 3d 92 04 | 07 3d 1e 0d 07 3d f6 0c |13R..=..|.=...=..|
|000004f0| 07 3d 46 0d 07 3d 76 0d | 07 3d fa 0f 07 3d aa 0f |.=F..=v.|.=...=..|
|00000500| 07 3d d2 0f 07 3d 22 10 | 07 3d 42 10 07 3d be 00 |.=...=".|.=B..=..|
|00000510| 97 3c d6 00 97 3c 6e 04 | 97 3c 0a 09 97 3c 86 00 |.<...<n.|.<...<..|
|00000520| 7f 0b 9e 00 7f 0b e6 0c | 7f 0b a6 0c 7f 0b 56 0c |........|......V.|
|00000530| 7f 0b 7e 0c 7f 0b ce 0c | 7f 0b fe 0c 7f 0b 2e 0d |..~.....|........|
|00000540| 7f 0b 01 00 00 00 00 00 | 0a 00 00 00 00 00 00 00 |........|........|
|00000550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000580| 00 00 00 00 00 00 25 00 | 00 00 00 00 00 00 00 00 |......%.|........|
|00000590| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005a0| 00 00 00 00 00 00 14 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005c0| 00 00 00 00 00 00 00 00 | 77 f5 f7 00 1f 00 77 f5 |........|w.....w.|
|000005d0| f7 00 1f 09 77 f5 f7 00 | 1f 01 77 f5 f7 00 1f 00 |....w...|..w.....|
|000005e0| 77 90 f7 00 0f 00 77 90 | f7 00 0f 09 77 90 f7 00 |w.....w.|....w...|
|000005f0| 0f 01 77 90 f7 00 0f 00 | 77 9e f7 00 0f 00 77 9e |..w.....|w.....w.|
|00000600| ff ff 08 00 37 00 00 00 | 73 65 6c 65 63 74 20 6e |....7...|select n|
|00000610| 61 6d 65 2c 20 73 74 72 | 65 65 74 20 66 72 6f 6d |ame, str|eet from|
|00000620| 20 43 75 73 74 6f 6d 65 | 72 20 6f 72 64 65 72 20 | Custome|r order |
|00000630| 62 79 20 6e 61 6d 65 00 | 76 0e 32 33 00 00 89 01 |by name.|v.23....|
|00000640| 00 00 02 00 00 00 00 00 | 0a 00 00 00 08 00 00 00 |........|........|
|00000650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000680| 00 00 00 00 00 00 29 00 | 28 00 00 00 00 00 00 00 |......).|(.......|
|00000690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006a0| 00 00 00 00 00 00 02 00 | 3b 00 00 00 00 00 00 00 |........|;.......|
|000006b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006c0| 00 00 00 00 00 00 0d 00 | 0a 0f 0a 0e 97 47 0e 0f |........|.....G..|
|000006d0| ef 47 f5 00 00 00 25 00 | 00 00 00 00 14 00 31 35 |.G....%.|......15|
|000006e0| 31 33 52 03 07 3d 92 04 | 07 3d 1e 0d 07 3d f6 0c |13R..=..|.=...=..|
|000006f0| 07 3d 46 0d 07 3d 76 0d | 07 3d fa 0f 07 3d aa 0f |.=F..=v.|.=...=..|
|00000700| 07 3d d2 0f 07 3d 22 10 | 07 3d 42 10 07 3d be 00 |.=...=".|.=B..=..|
|00000710| 97 3c d6 00 97 3c 6e 04 | 97 3c 0a 09 97 3c 86 00 |.<...<n.|.<...<..|
|00000720| 7f 0b 9e 00 7f 0b e6 0c | 7f 0b a6 0c 7f 0b 56 0c |........|......V.|
|00000730| 7f 0b 7e 0c 7f 0b ce 0c | 7f 0b fe 0c 7f 0b 2e 0d |..~.....|........|
|00000740| 7f 0b 01 00 00 00 00 00 | 0a 00 00 00 00 00 00 00 |........|........|
|00000750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000780| 00 00 00 00 00 00 25 00 | 00 00 00 00 00 00 00 00 |......%.|........|
|00000790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007a0| 00 00 00 00 00 00 14 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007c0| 00 00 00 00 00 00 00 00 | 77 f5 f7 00 1f 00 77 f5 |........|w.....w.|
|000007d0| f7 00 1f 09 77 f5 f7 00 | 1f 01 77 f5 f7 00 1f 00 |....w...|..w.....|
|000007e0| 77 90 f7 00 0f 00 77 90 | f7 00 0f 09 77 90 f7 00 |w.....w.|....w...|
|000007f0| 0f 01 77 90 f7 00 0f 00 | 77 9e f7 00 0f 00 77 9e |..w.....|w.....w.|
|00000800| ff ff 08 00 3b 00 00 00 | 75 73 65 20 43 75 73 74 |....;...|use Cust|
|00000810| 6f 6d 65 72 20 6f 72 64 | 65 72 20 6e 61 6d 65 0d |omer ord|er name.|
|00000820| 0a 73 65 74 20 66 69 65 | 6c 64 73 20 74 6f 20 6e |.set fie|lds to n|
|00000830| 61 6d 65 2c 20 73 74 72 | 65 65 74 33 00 00 89 01 |ame, str|eet3....|
|00000840| 00 00 02 00 00 00 00 00 | 0a 00 00 00 08 00 00 00 |........|........|
|00000850| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000860| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000870| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000880| 00 00 00 00 00 00 29 00 | 28 00 00 00 00 00 00 00 |......).|(.......|
|00000890| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008a0| 00 00 00 00 00 00 02 00 | 3b 00 00 00 00 00 00 00 |........|;.......|
|000008b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008c0| 00 00 00 00 00 00 0d 00 | 0a 0f 0a 0e 97 47 0e 0f |........|.....G..|
|000008d0| ef 47 f5 00 00 00 25 00 | 00 00 00 00 14 00 31 35 |.G....%.|......15|
|000008e0| 31 33 52 03 07 3d 92 04 | 07 3d 1e 0d 07 3d f6 0c |13R..=..|.=...=..|
|000008f0| 07 3d 46 0d 07 3d 76 0d | 07 3d fa 0f 07 3d aa 0f |.=F..=v.|.=...=..|
|00000900| 07 3d d2 0f 07 3d 22 10 | 07 3d 42 10 07 3d be 00 |.=...=".|.=B..=..|
|00000910| 97 3c d6 00 97 3c 6e 04 | 97 3c 0a 09 97 3c 86 00 |.<...<n.|.<...<..|
|00000920| 7f 0b 9e 00 7f 0b e6 0c | 7f 0b a6 0c 7f 0b 56 0c |........|......V.|
|00000930| 7f 0b 7e 0c 7f 0b ce 0c | 7f 0b fe 0c 7f 0b 2e 0d |..~.....|........|
|00000940| 7f 0b 01 00 00 00 00 00 | 0a 00 00 00 00 00 00 00 |........|........|
|00000950| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000960| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000970| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000980| 00 00 00 00 00 00 25 00 | 00 00 00 00 00 00 00 00 |......%.|........|
|00000990| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009a0| 00 00 00 00 00 00 14 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009c0| 00 00 00 00 00 00 00 00 | 77 f5 f7 00 1f 00 77 f5 |........|w.....w.|
|000009d0| f7 00 1f 09 77 f5 f7 00 | 1f 01 77 f5 f7 00 1f 00 |....w...|..w.....|
|000009e0| 77 90 f7 00 0f 00 77 90 | f7 00 0f 09 77 90 f7 00 |w.....w.|....w...|
|000009f0| 0f 01 77 90 f7 00 0f 00 | 77 9e f7 00 0f 00 77 9e |..w.....|w.....w.|
|00000a00| ff ff 08 00 26 00 00 00 | 75 73 65 20 69 6e 20 43 |....&...|use in C|
|00000a10| 75 73 74 6f 6d 65 72 0d | 0a 73 65 74 20 66 69 65 |ustomer.|.set fie|
|00000a20| 6c 64 73 20 74 6f 69 65 | 6c 64 73 20 74 6f 20 6e |lds toie|lds to n|
|00000a30| 61 6d 65 2c 20 73 74 72 | 65 65 74 33 00 00 89 01 |ame, str|eet3....|
|00000a40| 00 00 02 00 00 00 00 00 | 0a 00 00 00 08 00 00 00 |........|........|
|00000a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a80| 00 00 00 00 00 00 29 00 | 28 00 00 00 00 00 00 00 |......).|(.......|
|00000a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000aa0| 00 00 00 00 00 00 02 00 | 3b 00 00 00 00 00 00 00 |........|;.......|
|00000ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ac0| 00 00 00 00 00 00 0d 00 | 0a 0f 0a 0e 97 47 0e 0f |........|.....G..|
|00000ad0| ef 47 f5 00 00 00 25 00 | 00 00 00 00 14 00 31 35 |.G....%.|......15|
|00000ae0| 31 33 52 03 07 3d 92 04 | 07 3d 1e 0d 07 3d f6 0c |13R..=..|.=...=..|
|00000af0| 07 3d 46 0d 07 3d 76 0d | 07 3d fa 0f 07 3d aa 0f |.=F..=v.|.=...=..|
|00000b00| 07 3d d2 0f 07 3d 22 10 | 07 3d 42 10 07 3d be 00 |.=...=".|.=B..=..|
|00000b10| 97 3c d6 00 97 3c 6e 04 | 97 3c 0a 09 97 3c 86 00 |.<...<n.|.<...<..|
|00000b20| 7f 0b 9e 00 7f 0b e6 0c | 7f 0b a6 0c 7f 0b 56 0c |........|......V.|
|00000b30| 7f 0b 7e 0c 7f 0b ce 0c | 7f 0b fe 0c 7f 0b 2e 0d |..~.....|........|
|00000b40| 7f 0b 01 00 00 00 00 00 | 0a 00 00 00 00 00 00 00 |........|........|
|00000b50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b80| 00 00 00 00 00 00 25 00 | 00 00 00 00 00 00 00 00 |......%.|........|
|00000b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ba0| 00 00 00 00 00 00 14 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bc0| 00 00 00 00 00 00 00 00 | 77 f5 f7 00 1f 00 77 f5 |........|w.....w.|
|00000bd0| f7 00 1f 09 77 f5 f7 00 | 1f 01 77 f5 f7 00 1f 00 |....w...|..w.....|
|00000be0| 77 90 f7 00 0f 00 77 90 | f7 00 0f 09 77 90 f7 00 |w.....w.|....w...|
|00000bf0| 0f 01 77 90 f7 00 0f 00 | 77 9e f7 00 0f 00 77 9e |..w.....|w.....w.|
|00000c00| ff ff 08 00 dc 00 00 00 | 73 65 6c 65 63 74 20 64 |........|select d|
|00000c10| 69 73 74 69 6e 63 74 3b | 0d 0a 20 20 20 43 2e 6e |istinct;|..   C.n|
|00000c20| 61 6d 65 2c 20 4f 2e 6f | 72 64 65 72 5f 6e 6f 2c |ame, O.o|rder_no,|
|00000c30| 20 4c 2e 73 74 6f 63 6b | 5f 6e 6f 2c 20 4c 2e 71 | L.stock|_no, L.q|
|00000c40| 74 79 2c 20 4c 2e 73 65 | 6c 6c 5f 70 72 69 63 65 |ty, L.se|ll_price|
|00000c50| 3b 0d 0a 20 20 20 66 72 | 6f 6d 20 20 6f 72 64 65 |;..   fr|om  orde|
|00000c60| 72 73 20 4f 2c 20 63 75 | 73 74 6f 6d 65 72 20 43 |rs O, cu|stomer C|
|00000c70| 2c 20 6c 69 6e 65 69 74 | 65 6d 20 4c 3b 0d 0a 20 |, lineit|em L;.. |
|00000c80| 20 20 77 68 65 72 65 20 | 43 2e 63 75 73 74 6f 6d |  where |C.custom|
|00000c90| 65 72 5f 6e 20 3d 20 4f | 2e 63 75 73 74 6f 6d 65 |er_n = O|.custome|
|00000ca0| 72 5f 6e 3b 0d 0a 20 20 | 20 20 20 20 61 6e 64 20 |r_n;..  |    and |
|00000cb0| 4f 2e 6f 72 64 65 72 5f | 6e 6f 20 3d 20 4c 2e 6f |O.order_|no = L.o|
|00000cc0| 72 64 65 72 5f 6e 6f 3b | 0d 0a 20 20 20 6f 72 64 |rder_no;|..   ord|
|00000cd0| 65 72 20 62 79 20 43 2e | 6e 61 6d 65 14 00 31 35 |er by C.|name..15|
|00000ce0| 31 33 52 03 07 3d 92 04 | 07 3d 1e 0d 07 3d f6 0c |13R..=..|.=...=..|
|00000cf0| 07 3d 46 0d 07 3d 76 0d | 07 3d fa 0f 07 3d aa 0f |.=F..=v.|.=...=..|
|00000d00| 07 3d d2 0f 07 3d 22 10 | 07 3d 42 10 07 3d be 00 |.=...=".|.=B..=..|
|00000d10| 97 3c d6 00 97 3c 6e 04 | 97 3c 0a 09 97 3c 86 00 |.<...<n.|.<...<..|
|00000d20| 7f 0b 9e 00 7f 0b e6 0c | 7f 0b a6 0c 7f 0b 56 0c |........|......V.|
|00000d30| 7f 0b 7e 0c 7f 0b ce 0c | 7f 0b fe 0c 7f 0b 2e 0d |..~.....|........|
|00000d40| 7f 0b 01 00 00 00 00 00 | 0a 00 00 00 00 00 00 00 |........|........|
|00000d50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d80| 00 00 00 00 00 00 25 00 | 00 00 00 00 00 00 00 00 |......%.|........|
|00000d90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000da0| 00 00 00 00 00 00 14 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000db0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000dc0| 00 00 00 00 00 00 00 00 | 77 f5 f7 00 1f 00 77 f5 |........|w.....w.|
|00000dd0| f7 00 1f 09 77 f5 f7 00 | 1f 01 77 f5 f7 00 1f 00 |....w...|..w.....|
|00000de0| 77 90 f7 00 0f 00 77 90 | f7 00 0f 09 77 90 f7 00 |w.....w.|....w...|
|00000df0| 0f 01 77 90 f7 00 0f 00 | 77 9e f7 00 0f 00 77 9e |..w.....|w.....w.|
|00000e00| ff ff 08 00 a5 01 00 00 | 75 73 65 20 43 75 73 74 |........|use Cust|
|00000e10| 6f 6d 65 72 20 6f 72 64 | 65 72 20 6e 61 6d 65 20 |omer ord|er name |
|00000e20| 69 6e 20 73 65 6c 65 63 | 74 28 29 0d 0a 75 73 65 |in selec|t()..use|
|00000e30| 20 4f 72 64 65 72 73 20 | 6f 72 64 65 72 20 63 75 | Orders |order cu|
|00000e40| 73 74 6f 6d 65 72 5f 6e | 20 69 6e 20 73 65 6c 65 |stomer_n| in sele|
|00000e50| 63 74 28 29 0d 0a 75 73 | 65 20 4c 69 6e 65 69 74 |ct()..us|e Lineit|
|00000e60| 65 6d 20 6f 72 64 65 72 | 20 6f 72 64 65 72 5f 6e |em order| order_n|
|00000e70| 6f 20 69 6e 20 73 65 6c | 65 63 74 28 29 0d 0a 73 |o in sel|ect()..s|
|00000e80| 65 6c 65 63 74 20 43 75 | 73 74 6f 6d 65 72 0d 0a |elect Cu|stomer..|
|00000e90| 73 65 74 20 72 65 6c 61 | 74 69 6f 6e 20 74 6f 20 |set rela|tion to |
|00000ea0| 63 75 73 74 6f 6d 65 72 | 5f 6e 20 69 6e 74 6f 20 |customer|_n into |
|00000eb0| 4f 72 64 65 72 73 20 63 | 6f 6e 73 74 72 61 69 6e |Orders c|onstrain|
|00000ec0| 0d 0a 73 65 6c 65 63 74 | 20 4f 72 64 65 72 73 0d |..select| Orders.|
|00000ed0| 0a 73 65 74 20 72 65 6c | 61 74 69 6f 6e 20 74 6f |.set rel|ation to|
|00000ee0| 20 6f 72 64 65 72 5f 6e | 6f 20 69 6e 74 6f 20 4c | order_n|o into L|
|00000ef0| 69 6e 65 69 74 65 6d 20 | 63 6f 6e 73 74 72 61 69 |ineitem |constrai|
|00000f00| 6e 0d 0a 73 65 6c 65 63 | 74 20 43 75 73 74 6f 6d |n..selec|t Custom|
|00000f10| 65 72 0d 0a 73 65 74 20 | 73 6b 69 70 20 74 6f 20 |er..set |skip to |
|00000f20| 4f 72 64 65 72 73 2c 20 | 4c 69 6e 65 69 74 65 6d |Orders, |Lineitem|
|00000f30| 0d 0a 73 65 74 20 66 69 | 65 6c 64 73 20 74 6f 20 |..set fi|elds to |
|00000f40| 43 75 73 74 6f 6d 65 72 | 2d 3e 6e 61 6d 65 2c 20 |Customer|->name, |
|00000f50| 4f 72 64 65 72 73 2d 3e | 6f 72 64 65 72 5f 6e 6f |Orders->|order_no|
|00000f60| 2c 20 3b 0d 0a 20 20 20 | 4c 69 6e 65 69 74 65 6d |, ;..   |Lineitem|
|00000f70| 2d 3e 73 74 6f 63 6b 5f | 6e 6f 2c 20 4c 69 6e 65 |->stock_|no, Line|
|00000f80| 69 74 65 6d 2d 3e 71 74 | 79 2c 20 3b 0d 0a 20 20 |item->qt|y, ;..  |
|00000f90| 20 4c 69 6e 65 69 74 65 | 6d 2d 3e 73 65 6c 6c 5f | Lineite|m->sell_|
|00000fa0| 70 72 69 63 65 00 14 00 | 00 00 00 00 00 00 00 00 |price...|........|
|00000fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fc0| 00 00 00 00 00 00 00 00 | 77 f5 f7 00 1f 00 77 f5 |........|w.....w.|
|00000fd0| f7 00 1f 09 77 f5 f7 00 | 1f 01 77 f5 f7 00 1f 00 |....w...|..w.....|
|00000fe0| 77 90 f7 00 0f 00 77 90 | f7 00 0f 09 77 90 f7 00 |w.....w.|....w...|
|00000ff0| 0f 01 77 90 f7 00 0f 00 | 77 9e f7 00 0f 00 77 9e |..w.....|w.....w.|
|00001000| ff ff 08 00 46 00 00 00 | 75 73 65 20 69 6e 20 4c |....F...|use in L|
|00001010| 69 6e 65 69 74 65 6d 0d | 0a 75 73 65 20 69 6e 20 |ineitem.|.use in |
|00001020| 4f 72 64 65 72 73 0d 0a | 75 73 65 20 69 6e 20 43 |Orders..|use in C|
|00001030| 75 73 74 6f 6d 65 72 0d | 0a 73 65 74 20 66 69 65 |ustomer.|.set fie|
|00001040| 6c 64 73 20 74 6f 5f 6e | 20 69 6e 20 73 65 6c 65 |lds to_n| in sele|
|00001050| 63 74 28 29 0d 0a 75 73 | 65 20 6c 69 6e 65 69 74 |ct()..us|e lineit|
|00001060| 65 6d 20 6f 72 64 65 72 | 20 6f 72 64 65 72 5f 6e |em order| order_n|
|00001070| 6f 20 69 6e 20 73 65 6c | 65 63 74 28 29 0d 0a 73 |o in sel|ect()..s|
|00001080| 65 6c 65 63 74 20 63 75 | 73 74 6f 6d 65 72 0d 0a |elect cu|stomer..|
|00001090| 73 65 74 20 72 65 6c 61 | 74 69 6f 6e 20 74 6f 20 |set rela|tion to |
|000010a0| 63 75 73 74 6f 6d 65 72 | 5f 6e 20 69 6e 74 6f 20 |customer|_n into |
|000010b0| 6f 72 64 65 72 73 20 63 | 6f 6e 73 74 72 61 69 6e |orders c|onstrain|
|000010c0| 0d 0a 73 65 6c 65 63 74 | 20 6f 72 64 65 72 73 0d |..select| orders.|
|000010d0| 0a 73 65 74 20 72 65 6c | 61 74 69 6f 6e 20 74 6f |.set rel|ation to|
|000010e0| 20 6f 72 64 65 72 5f 6e | 6f 20 69 6e 74 6f 20 6c | order_n|o into l|
|000010f0| 69 6e 65 69 74 65 6d 20 | 63 6f 6e 73 74 72 61 69 |ineitem |constrai|
|00001100| 6e 0d 0a 73 65 6c 65 63 | 74 20 63 75 73 74 6f 6d |n..selec|t custom|
|00001110| 65 72 0d 0a 73 65 74 20 | 73 6b 69 70 20 74 6f 20 |er..set |skip to |
|00001120| 6f 72 64 65 72 73 2c 20 | 6c 69 6e 65 69 74 65 6d |orders, |lineitem|
|00001130| 0d 0a 73 65 74 20 66 69 | 65 6c 64 73 20 74 6f 20 |..set fi|elds to |
|00001140| 63 75 73 74 6f 6d 65 72 | 2d 3e 6e 61 6d 65 2c 20 |customer|->name, |
|00001150| 6f 72 64 65 72 73 2d 3e | 6f 72 64 65 72 5f 6e 6f |orders->|order_no|
|00001160| 2c 20 3b 0d 0a 20 20 20 | 6c 69 6e 65 69 74 65 6d |, ;..   |lineitem|
|00001170| 2d 3e 73 74 6f 63 6b 5f | 6e 6f 2c 20 6c 69 6e 65 |->stock_|no, line|
|00001180| 69 74 65 6d 2d 3e 71 74 | 79 2c 20 3b 0d 0a 20 20 |item->qt|y, ;..  |
|00001190| 20 6c 69 6e 65 69 74 65 | 6d 2d 3e 73 65 6c 6c 5f | lineite|m->sell_|
|000011a0| 70 72 69 63 65 00 14 00 | 00 00 00 00 00 00 00 00 |price...|........|
|000011b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011c0| 00 00 00 00 00 00 00 00 | 77 f5 f7 00 1f 00 77 f5 |........|w.....w.|
|000011d0| f7 00 1f 09 77 f5 f7 00 | 1f 01 77 f5 f7 00 1f 00 |....w...|..w.....|
|000011e0| 77 90 f7 00 0f 00 77 90 | f7 00 0f 09 77 90 f7 00 |w.....w.|....w...|
|000011f0| 0f 01 77 90 f7 00 0f 00 | 77 9e f7 00 0f 00 77 9e |..w.....|w.....w.|
|00001200| ff ff 08 00 ae 00 00 00 | 73 65 6c 65 63 74 20 43 |........|select C|
|00001210| 2e 6e 61 6d 65 2c 20 73 | 75 6d 28 4f 2e 61 6d 74 |.name, s|um(O.amt|
|00001220| 5f 70 61 69 64 29 20 74 | 6f 74 61 6c 5f 70 61 69 |_paid) t|otal_pai|
|00001230| 64 3b 0d 0a 20 20 20 66 | 72 6f 6d 20 20 43 75 73 |d;..   f|rom  Cus|
|00001240| 74 6f 6d 65 72 20 43 2c | 20 4f 72 64 65 72 73 20 |tomer C,| Orders |
|00001250| 4f 3b 0d 0a 20 20 20 77 | 68 65 72 65 20 43 2e 63 |O;..   w|here C.c|
|00001260| 75 73 74 6f 6d 65 72 5f | 6e 20 3d 20 4f 2e 63 75 |ustomer_|n = O.cu|
|00001270| 73 74 6f 6d 65 72 5f 6e | 3b 0d 0a 20 20 20 67 72 |stomer_n|;..   gr|
|00001280| 6f 75 70 20 62 79 20 63 | 75 73 74 6f 6d 65 72 5f |oup by c|ustomer_|
|00001290| 6e 20 20 68 61 76 69 6e | 67 20 6d 69 6e 28 61 6d |n  havin|g min(am|
|000012a0| 74 5f 70 61 69 64 29 20 | 3e 20 31 35 30 30 6f 20 |t_paid) |> 1500o |
|000012b0| 6f 72 64 65 72 73 20 63 | 6f 6e 73 74 72 61 69 6e |orders c|onstrain|
|000012c0| 0d 0a 73 65 6c 65 63 74 | 20 6f 72 64 65 72 73 0d |..select| orders.|
|000012d0| 0a 73 65 74 20 72 65 6c | 61 74 69 6f 6e 20 74 6f |.set rel|ation to|
|000012e0| 20 6f 72 64 65 72 5f 6e | 6f 20 69 6e 74 6f 20 6c | order_n|o into l|
|000012f0| 69 6e 65 69 74 65 6d 20 | 63 6f 6e 73 74 72 61 69 |ineitem |constrai|
|00001300| 6e 0d 0a 73 65 6c 65 63 | 74 20 63 75 73 74 6f 6d |n..selec|t custom|
|00001310| 65 72 0d 0a 73 65 74 20 | 73 6b 69 70 20 74 6f 20 |er..set |skip to |
|00001320| 6f 72 64 65 72 73 2c 20 | 6c 69 6e 65 69 74 65 6d |orders, |lineitem|
|00001330| 0d 0a 73 65 74 20 66 69 | 65 6c 64 73 20 74 6f 20 |..set fi|elds to |
|00001340| 63 75 73 74 6f 6d 65 72 | 2d 3e 6e 61 6d 65 2c 20 |customer|->name, |
|00001350| 6f 72 64 65 72 73 2d 3e | 6f 72 64 65 72 5f 6e 6f |orders->|order_no|
|00001360| 2c 20 3b 0d 0a 20 20 20 | 6c 69 6e 65 69 74 65 6d |, ;..   |lineitem|
|00001370| 2d 3e 73 74 6f 63 6b 5f | 6e 6f 2c 20 6c 69 6e 65 |->stock_|no, line|
|00001380| 69 74 65 6d 2d 3e 71 74 | 79 2c 20 3b 0d 0a 20 20 |item->qt|y, ;..  |
|00001390| 20 6c 69 6e 65 69 74 65 | 6d 2d 3e 73 65 6c 6c 5f | lineite|m->sell_|
|000013a0| 70 72 69 63 65 00 14 00 | 00 00 00 00 00 00 00 00 |price...|........|
|000013b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013c0| 00 00 00 00 00 00 00 00 | 77 f5 f7 00 1f 00 77 f5 |........|w.....w.|
|000013d0| f7 00 1f 09 77 f5 f7 00 | 1f 01 77 f5 f7 00 1f 00 |....w...|..w.....|
|000013e0| 77 90 f7 00 0f 00 77 90 | f7 00 0f 09 77 90 f7 00 |w.....w.|....w...|
|000013f0| 0f 01 77 90 f7 00 0f 00 | 77 9e f7 00 0f 00 77 9e |..w.....|w.....w.|
|00001400| ff ff 08 00 ca 00 00 00 | 75 73 65 20 43 75 73 74 |........|use Cust|
|00001410| 6f 6d 65 72 20 69 6e 20 | 73 65 6c 65 63 74 28 29 |omer in |select()|
|00001420| 20 6f 72 64 65 72 20 63 | 75 73 74 6f 6d 65 72 5f | order c|ustomer_|
|00001430| 6e 20 65 78 63 6c 75 73 | 69 76 65 0d 0a 73 65 6c |n exclus|ive..sel|
|00001440| 65 63 74 20 43 75 73 74 | 6f 6d 65 72 0d 0a 61 70 |ect Cust|omer..ap|
|00001450| 70 65 6e 64 20 62 6c 61 | 6e 6b 0d 0a 72 65 70 6c |pend bla|nk..repl|
|00001460| 61 63 65 20 6e 61 6d 65 | 20 77 69 74 68 20 22 64 |ace name| with "d|
|00001470| 42 41 53 45 20 43 75 73 | 74 6f 6d 65 72 22 2c 20 |BASE Cus|tomer", |
|00001480| 63 75 73 74 6f 6d 65 72 | 5f 6e 20 77 69 74 68 20 |customer|_n with |
|00001490| 22 30 30 30 30 22 0d 0a | 73 65 74 20 66 69 65 6c |"0000"..|set fiel|
|000014a0| 64 73 20 74 6f 20 43 75 | 73 74 6f 6d 65 72 2d 3e |ds to Cu|stomer->|
|000014b0| 6e 61 6d 65 2c 20 43 75 | 73 74 6f 6d 65 72 2d 3e |name, Cu|stomer->|
|000014c0| 63 75 73 74 6f 6d 65 72 | 5f 6e 72 64 65 72 73 0d |customer|_nrders.|
|000014d0| 0a 73 65 74 20 72 65 6c | 61 74 69 6f 6e 20 74 6f |.set rel|ation to|
|000014e0| 20 6f 72 64 65 72 5f 6e | 6f 20 69 6e 74 6f 20 6c | order_n|o into l|
|000014f0| 69 6e 65 69 74 65 6d 20 | 63 6f 6e 73 74 72 61 69 |ineitem |constrai|
|00001500| 6e 0d 0a 73 65 6c 65 63 | 74 20 63 75 73 74 6f 6d |n..selec|t custom|
|00001510| 65 72 0d 0a 73 65 74 20 | 73 6b 69 70 20 74 6f 20 |er..set |skip to |
|00001520| 6f 72 64 65 72 73 2c 20 | 6c 69 6e 65 69 74 65 6d |orders, |lineitem|
|00001530| 0d 0a 73 65 74 20 66 69 | 65 6c 64 73 20 74 6f 20 |..set fi|elds to |
|00001540| 63 75 73 74 6f 6d 65 72 | 2d 3e 6e 61 6d 65 2c 20 |customer|->name, |
|00001550| 6f 72 64 65 72 73 2d 3e | 6f 72 64 65 72 5f 6e 6f |orders->|order_no|
|00001560| 2c 20 3b 0d 0a 20 20 20 | 6c 69 6e 65 69 74 65 6d |, ;..   |lineitem|
|00001570| 2d 3e 73 74 6f 63 6b 5f | 6e 6f 2c 20 6c 69 6e 65 |->stock_|no, line|
|00001580| 69 74 65 6d 2d 3e 71 74 | 79 2c 20 3b 0d 0a 20 20 |item->qt|y, ;..  |
|00001590| 20 6c 69 6e 65 69 74 65 | 6d 2d 3e 73 65 6c 6c 5f | lineite|m->sell_|
|000015a0| 70 72 69 63 65 00 14 00 | 00 00 00 00 00 00 00 00 |price...|........|
|000015b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015c0| 00 00 00 00 00 00 00 00 | 77 f5 f7 00 1f 00 77 f5 |........|w.....w.|
|000015d0| f7 00 1f 09 77 f5 f7 00 | 1f 01 77 f5 f7 00 1f 00 |....w...|..w.....|
|000015e0| 77 90 f7 00 0f 00 77 90 | f7 00 0f 09 77 90 f7 00 |w.....w.|....w...|
|000015f0| 0f 01 77 90 f7 00 0f 00 | 77 9e f7 00 0f 00 77 9e |..w.....|w.....w.|
|00001600| ff ff 08 00 36 00 00 00 | 64 65 6c 65 74 65 20 66 |....6...|delete f|
|00001610| 72 6f 6d 20 43 75 73 74 | 6f 6d 65 72 20 77 68 65 |rom Cust|omer whe|
|00001620| 72 65 20 63 75 73 74 6f | 6d 65 72 5f 6e 20 3d 20 |re custo|mer_n = |
|00001630| 22 30 30 30 30 22 75 73 | 69 76 65 0d 0a 73 65 6c |"0000"us|ive..sel|
|00001640| 65 63 74 20 63 75 73 74 | 6f 6d 65 72 0d 0a 61 70 |ect cust|omer..ap|
|00001650| 70 65 6e 64 20 62 6c 61 | 6e 6b 0d 0a 72 65 70 6c |pend bla|nk..repl|
|00001660| 61 63 65 20 6e 61 6d 65 | 20 77 69 74 68 20 22 64 |ace name| with "d|
|00001670| 42 41 53 45 20 43 75 73 | 74 6f 6d 65 72 22 2c 20 |BASE Cus|tomer", |
|00001680| 63 75 73 74 6f 6d 65 72 | 5f 6e 20 77 69 74 68 20 |customer|_n with |
|00001690| 22 30 30 30 30 22 0d 0a | 73 65 74 20 66 69 65 6c |"0000"..|set fiel|
|000016a0| 64 73 20 74 6f 20 63 75 | 73 74 6f 6d 65 72 2d 3e |ds to cu|stomer->|
|000016b0| 6e 61 6d 65 2c 20 63 75 | 73 74 6f 6d 65 72 2d 3e |name, cu|stomer->|
|000016c0| 63 75 73 74 6f 6d 65 72 | 5f 6e 72 64 65 72 73 0d |customer|_nrders.|
|000016d0| 0a 73 65 74 20 72 65 6c | 61 74 69 6f 6e 20 74 6f |.set rel|ation to|
|000016e0| 20 6f 72 64 65 72 5f 6e | 6f 20 69 6e 74 6f 20 6c | order_n|o into l|
|000016f0| 69 6e 65 69 74 65 6d 20 | 63 6f 6e 73 74 72 61 69 |ineitem |constrai|
|00001700| 6e 0d 0a 73 65 6c 65 63 | 74 20 63 75 73 74 6f 6d |n..selec|t custom|
|00001710| 65 72 0d 0a 73 65 74 20 | 73 6b 69 70 20 74 6f 20 |er..set |skip to |
|00001720| 6f 72 64 65 72 73 2c 20 | 6c 69 6e 65 69 74 65 6d |orders, |lineitem|
|00001730| 0d 0a 73 65 74 20 66 69 | 65 6c 64 73 20 74 6f 20 |..set fi|elds to |
|00001740| 63 75 73 74 6f 6d 65 72 | 2d 3e 6e 61 6d 65 2c 20 |customer|->name, |
|00001750| 6f 72 64 65 72 73 2d 3e | 6f 72 64 65 72 5f 6e 6f |orders->|order_no|
|00001760| 2c 20 3b 0d 0a 20 20 20 | 6c 69 6e 65 69 74 65 6d |, ;..   |lineitem|
|00001770| 2d 3e 73 74 6f 63 6b 5f | 6e 6f 2c 20 6c 69 6e 65 |->stock_|no, line|
|00001780| 69 74 65 6d 2d 3e 71 74 | 79 2c 20 3b 0d 0a 20 20 |item->qt|y, ;..  |
|00001790| 20 6c 69 6e 65 69 74 65 | 6d 2d 3e 73 65 6c 6c 5f | lineite|m->sell_|
|000017a0| 70 72 69 63 65 00 14 00 | 00 00 00 00 00 00 00 00 |price...|........|
|000017b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017c0| 00 00 00 00 00 00 00 00 | 77 f5 f7 00 1f 00 77 f5 |........|w.....w.|
|000017d0| f7 00 1f 09 77 f5 f7 00 | 1f 01 77 f5 f7 00 1f 00 |....w...|..w.....|
|000017e0| 77 90 f7 00 0f 00 77 90 | f7 00 0f 09 77 90 f7 00 |w.....w.|....w...|
|000017f0| 0f 01 77 90 f7 00 0f 00 | 77 9e f7 00 0f 00 77 9e |..w.....|w.....w.|
|00001800| ff ff 08 00 1d 00 00 00 | 73 65 6c 65 63 74 20 2a |........|select *|
|00001810| 20 66 72 6f 6d 20 41 6e | 69 6d 61 6c 73 20 22 30 | from An|imals "0|
|00001820| 30 30 30 22 0d 0a 64 65 | 6c 65 74 65 0d 0a 70 61 |000"..de|lete..pa|
|00001830| 63 6b 0d 0a 75 73 65 20 | 69 6e 20 63 75 73 74 6f |ck..use |in custo|
|00001840| 6d 65 72 0d 0a 73 65 74 | 20 66 69 65 6c 64 73 20 |mer..set| fields |
|00001850| 74 6f 6e 64 20 62 6c 61 | 6e 6b 0d 0a 72 65 70 6c |tond bla|nk..repl|
|00001860| 61 63 65 20 6e 61 6d 65 | 20 77 69 74 68 20 22 64 |ace name| with "d|
|00001870| 42 41 53 45 20 43 75 73 | 74 6f 6d 65 72 22 2c 20 |BASE Cus|tomer", |
|00001880| 63 75 73 74 6f 6d 65 72 | 5f 6e 20 77 69 74 68 20 |customer|_n with |
|00001890| 22 30 30 30 30 22 0d 0a | 73 65 74 20 66 69 65 6c |"0000"..|set fiel|
|000018a0| 64 73 20 74 6f 20 63 75 | 73 74 6f 6d 65 72 2d 3e |ds to cu|stomer->|
|000018b0| 6e 61 6d 65 2c 20 63 75 | 73 74 6f 6d 65 72 2d 3e |name, cu|stomer->|
|000018c0| 63 75 73 74 6f 6d 65 72 | 5f 6e 72 64 65 72 73 0d |customer|_nrders.|
|000018d0| 0a 73 65 74 20 72 65 6c | 61 74 69 6f 6e 20 74 6f |.set rel|ation to|
|000018e0| 20 6f 72 64 65 72 5f 6e | 6f 20 69 6e 74 6f 20 6c | order_n|o into l|
|000018f0| 69 6e 65 69 74 65 6d 20 | 63 6f 6e 73 74 72 61 69 |ineitem |constrai|
|00001900| 6e 0d 0a 73 65 6c 65 63 | 74 20 63 75 73 74 6f 6d |n..selec|t custom|
|00001910| 65 72 0d 0a 73 65 74 20 | 73 6b 69 70 20 74 6f 20 |er..set |skip to |
|00001920| 6f 72 64 65 72 73 2c 20 | 6c 69 6e 65 69 74 65 6d |orders, |lineitem|
|00001930| 0d 0a 73 65 74 20 66 69 | 65 6c 64 73 20 74 6f 20 |..set fi|elds to |
|00001940| 63 75 73 74 6f 6d 65 72 | 2d 3e 6e 61 6d 65 2c 20 |customer|->name, |
|00001950| 6f 72 64 65 72 73 2d 3e | 6f 72 64 65 72 5f 6e 6f |orders->|order_no|
|00001960| 2c 20 3b 0d 0a 20 20 20 | 6c 69 6e 65 69 74 65 6d |, ;..   |lineitem|
|00001970| 2d 3e 73 74 6f 63 6b 5f | 6e 6f 2c 20 6c 69 6e 65 |->stock_|no, line|
|00001980| 69 74 65 6d 2d 3e 71 74 | 79 2c 20 3b 0d 0a 20 20 |item->qt|y, ;..  |
|00001990| 20 6c 69 6e 65 69 74 65 | 6d 2d 3e 73 65 6c 6c 5f | lineite|m->sell_|
|000019a0| 70 72 69 63 65 00 14 00 | 00 00 00 00 00 00 00 00 |price...|........|
|000019b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019c0| 00 00 00 00 00 00 00 00 | 77 f5 f7 00 1f 00 77 f5 |........|w.....w.|
|000019d0| f7 00 1f 09 77 f5 f7 00 | 1f 01 77 f5 f7 00 1f 00 |....w...|..w.....|
|000019e0| 77 90 f7 00 0f 00 77 90 | f7 00 0f 09 77 90 f7 00 |w.....w.|....w...|
|000019f0| 0f 01 77 90 f7 00 0f 00 | 77 9e f7 00 0f 00 77 9e |..w.....|w.....w.|
|00001a00| ff ff 08 00 52 00 00 00 | 73 65 6c 65 63 74 20 43 |....R...|select C|
|00001a10| 75 73 74 6f 6d 65 72 0d | 0a 73 65 65 6b 20 22 30 |ustomer.|.seek "0|
|00001a20| 30 30 30 22 0d 0a 64 65 | 6c 65 74 65 0d 0a 70 61 |000"..de|lete..pa|
|00001a30| 63 6b 0d 0a 75 73 65 20 | 69 6e 20 43 75 73 74 6f |ck..use |in Custo|
|00001a40| 6d 65 72 0d 0a 73 65 74 | 20 66 69 65 6c 64 73 20 |mer..set| fields |
|00001a50| 74 6f 7f 2d 76 14 7f 2d | e9 14 7f 2d 9a 15 7f 2d |to.-v..-|...-...-|
|00001a60| c6 16 7f 2d 00 00 00 00 | f0 28 00 00 87 0b f0 5c |...-....|.(.....\|
|00001a70| 87 0b f0 51 87 0b cc cc | cc cc cc cc cc cc 87 3c |...Q....|.......<|
|00001a80| 02 00 a8 72 87 3c c8 53 | c7 2f 38 6d 87 0b 00 00 |...r.<.S|./8m....|
|00001a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ab0| 4c 07 6f 47 00 00 1d 01 | 4f 30 4d 01 4f 30 cb 07 |L.oG....|O0M.O0..|
|00001ac0| f7 1c 0e 08 f7 1c 51 08 | f7 1c bf 0b f7 1c 1e 14 |......Q.|........|
|00001ad0| f7 1c 5a 14 f7 1c 16 12 | f7 1c 18 11 f7 1c 0c 0c |..Z.....|........|
|00001ae0| f7 1c 40 0c f7 1c 71 12 | f7 1c 7a 13 f7 1c e4 13 |..@...q.|..z.....|
|00001af0| f7 1c e0 01 4f 30 1d 02 | 4f 30 9b 0c f7 1c 04 0d |....O0..|O0......|
|00001b00| f7 1c 98 0d f7 1c 25 03 | 4f 30 43 16 f7 1c 59 03 |......%.|O0C...Y.|
|00001b10| 4f 30 32 10 f7 1c 90 03 | 4f 30 37 10 4f 30 c1 03 |O02.....|O07.O0..|
|00001b20| 4f 30 44 04 07 21 07 04 | 4f 30 47 04 4f 30 81 04 |O0D..!..|O0G.O0..|
|00001b30| 4f 30 bb 04 4f 30 fb 04 | 4f 30 2d 05 4f 30 1e 13 |O0..O0..|O0-.O0..|
|00001b40| 4f 30 56 13 4f 30 8b 13 | 4f 30 aa 08 4f 30 6e 05 |O0V.O0..|O0..O0n.|
|00001b50| 4f 30 bd 13 4f 30 fe 13 | 4f 30 3c 14 4f 30 55 18 |O0..O0..|O0<.O0U.|
|00001b60| f7 1c b9 18 f7 1c 02 19 | f7 1c 59 19 f7 1c aa 19 |........|..Y.....|
|00001b70| f7 1c f1 19 f7 1c a2 12 | f7 1c ad 05 4f 30 e2 05 |........|....O0..|
|00001b80| 4f 30 17 06 4f 30 46 06 | 4f 30 25 0a f7 1c 14 08 |O0..O0F.|O0%.....|
|00001b90| 4f 30 04 13 f7 1c 6f 08 | 4f 30 e7 09 4f 30 4d 1a |O0....o.|O0..O0M.|
|00001ba0| f7 1c bb 09 4f 30 1c 0a | 4f 30 4b 0a 4f 30 77 0a |....O0..|O0K.O0w.|
|00001bb0| 4f 30 a9 0a 4f 30 de 0a | 4f 30 10 0b 4f 30 5a 0b |O0..O0..|O0..O0Z.|
|00001bc0| 4f 30 8f 0b 4f 30 c1 0b | 4f 30 ed 0b 4f 30 28 0c |O0..O0..|O0..O0(.|
|00001bd0| 4f 30 63 0c 4f 30 9b 0c | 4f 30 d3 0c 4f 30 08 0d |O0c.O0..|O0..O0..|
|00001be0| 4f 30 34 0d 4f 30 60 0d | 4f 30 8c 0d 4f 30 bb 0d |O04.O0`.|O0..O0..|
|00001bf0| 4f 30 ed 0d 4f 30 25 0e | 4f 30 ce 14 f7 1c 98 0e |O0..O0%.|O0......|
|00001c00| ff ff 08 00 67 01 00 00 | 75 73 65 20 4f 72 64 65 |....g...|use Orde|
|00001c10| 72 73 20 6f 72 64 65 72 | 20 63 75 73 74 6f 6d 65 |rs order| custome|
|00001c20| 72 5f 6e 20 69 6e 20 73 | 65 6c 65 63 74 28 29 0d |r_n in s|elect().|
|00001c30| 0a 73 65 6c 65 63 74 20 | 4f 72 64 65 72 73 0d 0a |.select |Orders..|
|00001c40| 74 6f 74 61 6c 20 6f 6e | 20 63 75 73 74 6f 6d 65 |total on| custome|
|00001c50| 72 5f 6e 20 74 6f 20 54 | 6f 74 61 6c 30 20 66 69 |r_n to T|otal0 fi|
|00001c60| 65 6c 64 73 20 61 6d 74 | 5f 70 61 69 64 0d 0a 75 |elds amt|_paid..u|
|00001c70| 73 65 20 54 6f 74 61 6c | 30 20 20 0d 0a 75 73 65 |se Total|0  ..use|
|00001c80| 20 43 75 73 74 6f 6d 65 | 72 20 69 6e 20 73 65 6c | Custome|r in sel|
|00001c90| 65 63 74 28 29 0d 0a 6a | 6f 69 6e 20 77 69 74 68 |ect()..j|oin with|
|00001ca0| 20 43 75 73 74 6f 6d 65 | 72 20 74 6f 20 54 6f 74 | Custome|r to Tot|
|00001cb0| 61 6c 31 3b 0d 0a 20 20 | 20 66 6f 72 20 63 75 73 |al1;..  | for cus|
|00001cc0| 74 6f 6d 65 72 5f 6e 20 | 3d 20 43 75 73 74 6f 6d |tomer_n |= Custom|
|00001cd0| 65 72 2d 3e 63 75 73 74 | 6f 6d 65 72 5f 6e 20 2e |er->cust|omer_n .|
|00001ce0| 61 6e 64 2e 3b 0d 0a 20 | 20 20 20 20 20 54 6f 74 |and.;.. |     Tot|
|00001cf0| 61 6c 30 2d 3e 61 6d 74 | 5f 70 61 69 64 20 3e 20 |al0->amt|_paid > |
|00001d00| 31 35 30 30 3b 0d 0a 20 | 20 20 66 69 65 6c 64 73 |1500;.. |  fields|
|00001d10| 20 63 75 73 74 6f 6d 65 | 72 2d 3e 6e 61 6d 65 2c | custome|r->name,|
|00001d20| 20 54 6f 74 61 6c 30 2d | 3e 61 6d 74 5f 70 61 69 | Total0-|>amt_pai|
|00001d30| 64 0d 0a 75 73 65 20 54 | 6f 74 61 6c 31 20 65 78 |d..use T|otal1 ex|
|00001d40| 63 6c 75 73 69 76 65 0d | 0a 69 6e 64 65 78 20 6f |clusive.|.index o|
|00001d50| 6e 20 6e 61 6d 65 20 74 | 61 67 20 6e 61 6d 65 0d |n name t|ag name.|
|00001d60| 0a 67 6f 20 74 6f 70 00 | 00 80 80 00 80 00 00 00 |.go top.|........|
|00001d70| 80 00 80 00 80 80 00 00 | c0 c0 c0 00 80 80 80 00 |........|........|
|00001d80| 00 00 ff 00 00 ff 00 00 | 00 ff ff 00 ff 00 00 00 |........|........|
|00001d90| ff 00 ff 00 ff ff 00 00 | ff ff 09 00 68 34 f7 47 |........|....h4.G|
|00001da0| 01 00 01 00 07 00 01 02 | 77 77 77 00 87 77 77 77 |........|www..www|
|00001db0| 77 77 77 00 87 77 77 70 | 77 77 77 00 87 77 77 00 |www..wwp|www..ww.|
|00001dc0| 77 77 77 00 87 77 70 00 | 00 07 77 00 87 77 00 00 |www..wp.|..w..w..|
|00001dd0| 00 07 77 00 87 77 70 00 | 00 07 77 00 87 77 77 00 |..w..wp.|..w..ww.|
|00001de0| 77 77 77 00 87 77 77 70 | 77 77 77 00 87 77 77 77 |www..wwp|www..www|
|00001df0| 77 77 77 00 87 77 77 77 | 77 77 77 00 87 77 77 77 |www..www|www..www|
|00001e00| ff ff 08 00 50 00 00 00 | 75 73 65 20 69 6e 20 43 |....P...|use in C|
|00001e10| 75 73 74 6f 6d 65 72 0d | 0a 75 73 65 20 69 6e 20 |ustomer.|.use in |
|00001e20| 54 6f 74 61 6c 31 0d 0a | 64 65 6c 65 74 65 20 74 |Total1..|delete t|
|00001e30| 61 62 6c 65 20 54 6f 74 | 61 6c 30 0d 0a 64 65 6c |able Tot|al0..del|
|00001e40| 65 74 65 20 74 61 62 6c | 65 20 54 6f 74 61 6c 31 |ete tabl|e Total1|
|00001e50| 6f 3b 0d 0a 20 20 20 77 | 68 65 72 65 20 63 2e 63 |o;..   w|here c.c|
|00001e60| 75 73 74 6f 6d 65 72 5f | 6e 20 3d 20 6f 2e 63 75 |ustomer_|n = o.cu|
|00001e70| 73 74 6f 6d 65 72 5f 6e | 3b 0d 0a 20 20 20 67 72 |stomer_n|;..   gr|
|00001e80| 6f 75 70 20 62 79 20 63 | 75 73 74 6f 6d 65 72 5f |oup by c|ustomer_|
|00001e90| 6e 20 20 26 26 20 68 61 | 76 69 6e 67 20 6d 69 6e |n  && ha|ving min|
|00001ea0| 28 61 6d 74 5f 70 61 69 | 64 29 20 3e 20 35 30 30 |(amt_pai|d) > 500|
|00001eb0| 20 35 30 30 89 56 ea c4 | 5e 06 26 c4 5f 06 26 8b | 500.V..|^.&._.&.|
|00001ec0| 7f 14 33 f6 16 8d 46 fc | 50 9a e1 07 6f 33 68 00 |..3...F.|P...o3h.|
|00001ed0| 01 9a 67 07 6f 33 89 56 | f6 89 46 f4 66 83 7e f4 |..g.o3.V|..F.f.~.|
|00001ee0| 00 75 03 e9 90 01 c4 5e | 06 26 ff 77 0c 26 ff 77 |.u.....^|.&.w.&.w|
|00001ef0| 0a c4 5e 06 26 c4 5f 0a | 26 ff 5f 02 52 50 ff 76 |..^.&._.|&._.RP.v|
|00001f00| f6 ff 76 f4 9a 5c 1a 07 | 32 83 c4 08 c4 5e f4 26 |..v..\..|2....^.&|
|00001f10| 80 3f 00 74 03 be ff ff | 66 ff 76 ee ff 76 ec ff |.?.t....|f.v..v..|
|00001f20| 76 ea 57 6a 01 9a 40 0f | cf 3b 89 46 f2 81 7e f2 |v.Wj..@.|.;.F..~.|
|00001f30| 01 2a 0f 85 8f 00 c4 1e | 14 2f 26 c4 9f 98 00 26 |.*......|./&....&|
|00001f40| c4 5f 04 26 c4 5f 29 8b | c7 48 6b c0 34 03 d8 26 |._.&._).|.Hk.4..&|
|00001f50| 81 7f 22 20 04 75 6b c4 | 5e 06 26 8b 47 14 40 50 |.." .uk.|^.&.G.@P|
|00001f60| 9a 67 07 6f 33 89 56 fa | 89 46 f8 66 83 7e f8 00 |.g.o3.V.|.F.f.~..|
|00001f70| 75 03 e9 01 01 66 ff 76 | ee 57 ff 76 ec ff 76 ea |u....f.v|.W.v..v.|
|00001f80| ff 76 fa ff 76 f8 16 8d | 46 e8 50 9a c0 10 cf 3b |.v..v...|F.P....;|
|00001f90| 83 7e e8 00 74 12 c4 5e | f4 26 80 3f 00 74 05 b8 |.~..t..^|.&.?.t..|
|00001fa0| ff ff eb 02 33 c0 eb 18 | ff 76 fa ff 76 f8 ff 76 |....3...|.v..v..v|
|00001fb0| f6 ff 76 f4 c4 5e 06 26 | ff 77 14 9a 7b 1a bf 32 |..v..^.&|.w..{..2|
|00001fc0| 8b f0 e9 b1 00 83 7e f2 | 00 74 03 e9 a8 00 68 01 |......~.|.t....h.|
|00001fd0| 01 9a 67 07 6f 33 89 56 | fa 89 46 f8 66 83 7e f8 |..g.o3.V|..F.f.~.|
|00001fe0| 00 0f 84 81 00 66 c7 46 | e6 00 00 00 00 c4 5e f8 |.....f.F|......^.|
|00001ff0| 26 c6 07 00 66 ff 76 ee | ff 76 ec ff 76 ea 57 66 |&...f.v.|.v..v.Wf|
|00002000| ff ff 08 00 90 00 00 00 | 69 6e 73 65 72 74 20 69 |........|insert i|
|00002010| 6e 74 6f 20 43 75 73 74 | 6f 6d 65 72 20 28 6e 61 |nto Cust|omer (na|
|00002020| 6d 65 2c 20 63 75 73 74 | 6f 6d 65 72 5f 6e 29 3b |me, cust|omer_n);|
|00002030| 0d 0a 20 20 20 20 76 61 | 6c 75 65 73 20 28 22 53 |..    va|lues ("S|
|00002040| 51 4c 20 43 75 73 74 6f | 6d 65 72 22 2c 20 22 30 |QL Custo|mer", "0|
|00002050| 30 30 30 22 29 0d 0a 73 | 65 6c 65 63 74 20 6e 61 |000")..s|elect na|
|00002060| 6d 65 2c 20 63 75 73 74 | 6f 6d 65 72 5f 6e 20 66 |me, cust|omer_n f|
|00002070| 72 6f 6d 20 43 75 73 74 | 6f 6d 65 72 20 6f 72 64 |rom Cust|omer ord|
|00002080| 65 72 20 62 79 20 63 75 | 73 74 6f 6d 65 72 5f 6e |er by cu|stomer_n|
|00002090| 65 63 74 28 29 0d 0a 6a | 6f 69 6e 20 77 69 74 68 |ect()..j|oin with|
|000020a0| 20 43 75 73 74 6f 6d 65 | 72 20 74 6f 20 54 6f 74 | Custome|r to Tot|
|000020b0| 61 6c 31 3b 0d 0a 20 20 | 20 66 6f 72 20 63 75 73 |al1;..  | for cus|
|000020c0| 74 6f 6d 65 72 5f 6e 20 | 3d 20 63 75 73 74 6f 6d |tomer_n |= custom|
|000020d0| 65 72 2d 3e 63 75 73 74 | 6f 6d 65 72 5f 6e 3b 0d |er->cust|omer_n;.|
|000020e0| 0a 20 20 20 66 69 65 6c | 64 73 20 63 75 73 74 6f |.   fiel|ds custo|
|000020f0| 6d 65 72 2d 3e 6e 61 6d | 65 2c 20 74 6f 74 61 6c |mer->nam|e, total|
|00002100| 2d 3e 61 6d 74 5f 70 61 | 69 64 0d 0a 75 73 65 20 |->amt_pa|id..use |
|00002110| 54 6f 74 61 6c 31 20 65 | 78 63 6c 0d 0a 69 6e 64 |Total1 e|xcl..ind|
|00002120| 65 78 20 6f 6e 20 6e 61 | 6d 65 20 74 61 67 20 6e |ex on na|me tag n|
|00002130| 61 6d 65 0d 0a 67 6f 20 | 74 6f 70 0d 0a c0 75 e4 |ame..go |top...u.|
|00002140| e8 04 03 00 00 8b 45 d0 | 5f 5e 5b 8b e5 5d c3 56 |......E.|_^[..].V|
|00002150| ff 74 24 08 e8 ae f9 ff | ff 83 c4 04 8b f0 85 f6 |.t$.....|........|
|00002160| 74 16 56 ff 15 ac f2 40 | 00 85 c0 74 0b 56 e8 53 |t.V....@|...t.V.S|
|00002170| fe ff ff 83 c4 04 eb 05 | b8 ff ff ff ff 5e c3 a1 |........|.....^..|
|00002180| 58 e0 40 00 50 e8 f8 f2 | ff ff 83 c4 04 85 c0 b8 |X.@.P...|........|
|00002190| 00 00 00 00 74 1c 6a 00 | 68 f5 19 40 00 ff 74 24 |....t.j.|h..@..t$|
|000021a0| 0c 68 d3 07 00 00 ff 35 | 58 e0 40 00 ff 15 8c f2 |.h.....5|X.@.....|
|000021b0| 40 00 c3 56 ff 74 24 08 | e8 4a f9 ff ff 83 c4 04 |@..V.t$.|.J......|
|000021c0| 8b f0 85 f6 74 0b 56 ff | 15 ac f2 40 00 85 c0 75 |....t.V.|...@...u|
|000021d0| 08 ff 15 c0 f2 40 00 8b | f0 56 e8 04 00 00 00 33 |.....@..|.V.....3|
|000021e0| c0 5e c3 56 68 4c 20 40 | 00 ff 15 00 f2 40 00 8b |.^.VhL @|.....@..|
|000021f0| f0 85 f6 74 26 68 5c 20 | 40 00 56 ff 15 18 f2 40 |...t&h\ |@.V....@|
|00002200| ff ff 08 00 b0 00 00 00 | 73 65 6c 65 63 74 20 43 |........|select C|
|00002210| 2e 6e 61 6d 65 2c 20 73 | 75 6d 28 4f 2e 61 6d 74 |.name, s|um(O.amt|
|00002220| 5f 70 61 69 64 29 20 74 | 6f 74 61 6c 5f 70 61 69 |_paid) t|otal_pai|
|00002230| 64 3b 0d 0a 20 20 20 66 | 72 6f 6d 20 20 43 75 73 |d;..   f|rom  Cus|
|00002240| 74 6f 6d 65 72 20 43 2c | 20 4f 72 64 65 72 73 20 |tomer C,| Orders |
|00002250| 4f 3b 0d 0a 20 20 20 77 | 68 65 72 65 20 43 2e 63 |O;..   w|here C.c|
|00002260| 75 73 74 6f 6d 65 72 5f | 6e 20 3d 20 4f 2e 63 75 |ustomer_|n = O.cu|
|00002270| 73 74 6f 6d 65 72 5f 6e | 3b 0d 0a 20 20 20 67 72 |stomer_n|;..   gr|
|00002280| 6f 75 70 20 62 79 20 63 | 75 73 74 6f 6d 65 72 5f |oup by c|ustomer_|
|00002290| 6e 20 20 68 61 76 69 6e | 67 20 6d 69 6e 28 4f 2e |n  havin|g min(O.|
|000022a0| 61 6d 74 5f 70 61 69 64 | 29 20 3e 20 31 35 30 30 |amt_paid|) > 1500|
|000022b0| 61 6c 31 3b 0d 0a 20 20 | 20 66 6f 72 20 63 75 73 |al1;..  | for cus|
|000022c0| 74 6f 6d 65 72 5f 6e 20 | 3d 20 43 75 73 74 6f 6d |tomer_n |= Custom|
|000022d0| 65 72 2d 3e 63 75 73 74 | 6f 6d 65 72 5f 6e 3b 0d |er->cust|omer_n;.|
|000022e0| 0a 20 20 20 66 69 65 6c | 64 73 20 63 75 73 74 6f |.   fiel|ds custo|
|000022f0| 6d 65 72 2d 3e 6e 61 6d | 65 2c 20 54 6f 74 61 6c |mer->nam|e, Total|
|00002300| 30 2d 3e 61 6d 74 5f 70 | 61 69 64 0d 0a 75 73 65 |0->amt_p|aid..use|
|00002310| 20 54 6f 74 61 6c 31 20 | 65 78 63 6c 75 73 69 76 | Total1 |exclusiv|
|00002320| 65 0d 0a 69 6e 64 65 78 | 20 6f 6e 20 6e 61 6d 65 |e..index| on name|
|00002330| 20 74 61 67 20 6e 61 6d | 65 0d 0a 67 6f 20 74 6f | tag nam|e..go to|
|00002340| 70 44 ff ff ff 83 7d f0 | ff 0f 84 b9 02 00 00 83 |pD....}.|........|
|00002350| 7d e4 ff 75 0b 8b 45 cc | 33 ff 89 45 e4 89 7d e8 |}..u..E.|3..E..}.|
|00002360| 83 7d f8 ff 75 38 8b 45 | f0 8b c8 89 45 f8 c1 e1 |.}..u8.E|....E...|
|00002370| 06 8b 86 a6 00 00 00 8d | 44 01 08 8b 48 0c 39 4d |........|D...H.9M|
|00002380| 18 0f 82 81 02 00 00 39 | 4d 10 0f 87 78 02 00 00 |.......9|M...x...|
|00002390| c7 45 ec ff ff ff 7f 8b | 40 20 48 89 45 d8 8b 4d |.E......|@ H.E..M|
|000023a0| e4 8b 86 a6 00 00 00 c1 | e1 06 89 7d f4 6b ff 3c |........|...}.k.<|
|000023b0| 8d 5c 01 08 8b 4d e4 89 | 4d fc 03 3b 8b 43 08 8d |.\...M..|M..;.C..|
|000023c0| 4d c4 83 c0 28 50 89 45 | f0 51 e8 5c af ff ff 03 |M...(P.E|.Q.\....|
|000023d0| 45 f0 8b 55 c5 89 45 f0 | 01 55 f0 8b 45 fc 39 45 |E..U..E.|.U..E.9E|
|000023e0| f8 75 0c 8b 45 f4 39 45 | d8 0f 8c e4 01 00 00 83 |.u..E.9E|........|
|000023f0| 7d fc ff 75 08 8b 86 ba | 00 00 00 eb 0f 8b 45 fc |}..u....|......E.|
+--------+-------------------------+-------------------------+--------+--------+